Page Setup

Overview

The Page Setup window allows users to customize the layout of their output when exporting a View, Dashboard or Report.

 

To access the Page Setup window, navigate to the Settings menu (right-hand panel of an open View, Dashboard or Report) and click on Sharing then select Page Setup.

General Tab

Related to Views, Dashboards and Reports

The General tab (shown below) allows the user to define the general configuration options of their export page.

Fields and Values

Orientation - Allows the user to define whether the page will be exported in portrait or landscape orientation

Unit - Allows the user to define the unit of measurement (i.e., centimetres or inches) displayed for paper size and margins.

Paper Size - Allows the user to set a standardized page size (i.e., width and height) for their export; users can also define a width and height manually by selecting the Custom Size option then entering the desired values in the Width and Height fields

Width - Field that represents the width of the export page; its value will update automatically depending on the options selected in the previous three fields, however, users will only be able to change the value manually if the Custom Size option is selected in the Paper Size field

Height - Field that represents the height of the export page; its behaviour is identical to the Width field

Fit to - page(s) wide - Toggle that allows users to define the number of pages within which the content of their export will be fit; Fit to - page(s) wide and Zoom (%) are mutually exclusive options

Zoom (%) - Toggle that allows users to define the zoom percentage to which their export will be displayed; Fit to - page(s) wide and Zoom (%) are mutually exclusive options

Confirm - Allows users to save any adjustments made to the page setup.

Note  

The Fit to - page(s) wide and Zoom (%) options only appear in the General tab if they are applicable to the export type.

Margins Tab

Related to Views, Dashboards and Reports

The Margins tab allows users to configure the margins of their export. The tab also provides a simplified margin preview in the centre of the Page Setup window which updates in real-time based on the values entered by the user.

Fields and Values

Default - Button that causes all export margins to revert to their initial, default values

Top, Left, Right and Bottom - Fields that allow the user to define the distance between their export content and the border of the page in all four directions

Header and Footer - Fields that allow the user to define the space between their header or footer and the top or bottom border of the page respectively; the values in these fields should always be less than the margin values to avoid overlapping

Header / Footer Tab

Related to Views, Dashboards and Reports

The Header / Footer tab (shown below) allows users to customize headers and footers and then add them to their export. The tab also provides a preview of how the header or footer will appear in the export.

Fields and Values

Customize Header - Allows users to customize their export's header; clicking the Customize Header button will display the Header Customization pop-up (see below)

 

Customize Footer - Allows users to customize their export's footer; clicking the Customize Footer button will display the Footer Customization pop-up (see below)

 

Confirm - Button that finalizes any header or footer customizations entered by the user in the Header / Footer tab

Header / Footer Customization Pop-Up

The Header or Footer Customization pop-up (shown below) is where users can create and edit their export's headers or footers respectively.

Fields and Values

Left Section - Text editing box for left-justified header or footer text

Center Section - Text editing box for center-justified header or footer text

Right Section - Text editing box for right-justified header or footer text

 

To begin adding header or footer text, click anywhere in the desired section and begin typing.

Note  

XLSX and XLS exports have a 255 character limit for headers and footers. Therefore, all 3 header or footer sections (i.e., left, center and right) combined must have less than 255 characters total. If your header or footer has more than 255 combined characters, the text will be truncated after the first 252 characters in XLSX and XLS exports.

Note  

.CSV file format does not support Nectari's Header / Footer feature. Therefore, headers and footers will not appear on any .CSV exports.

 

Formatting Toolbar

The formatting toolbar at the top of the pop-up window (shown below) allows users to further edit and customize their export's headers and footers.

 

From left to right, the formatting toolbar options are:

Bold - Makes the header or footer text bold

Italic - Makes the header or footer text italicized

Underline - Underlines the header or footer text

Strikethrough - Makes the header or footer text strikethrough

Font Size - Allows the user to change the font size of their header or footer text; the default font size is 9 for headers and 8 for footers

Font Color - Allows the user to change the colour of their header or footer text; the default font colour for headers and footers is black

Insert Image - Allows the user to insert an uploaded image file into their header or footer; this feature is incompatible with XLS exports since Excel does not support images in headers or footers

Insert Keyword - Drop-down list that allows users to insert both Nectari-specific and general keywords (e.g., External Link, Data Model Parameters, Date, etc.) into their header or footer; certain keyword options (i.e., Date, Time, Data Model Parameters and Global Variables) will cause a second drop-down list to appear to the right from which users can select additional options regarding the keyword type before inserting it into their header or footer text

 
Keyword Types
  • View Name - Inserts the name of the exported view

  • Chart Name - Inserts the name of the exported chart

  • Dashboard Name - Inserts the name of the exported dashboard

  • Report Name - Inserts the name of the exported report

  • Filter - Inserts the name of any filters currently applied to the export

  • Data Model Parameters - Inserts the name of a data model parameter; the user chooses which data model parameter name they want to insert from the secondary keyword drop-down list

  • Data Model Name - Inserts the name of the data model associated with the export

  • Page Number - Inserts the current page number; this keyword will update to match each page of the export; this keyword is incompatible with HTML and XML exports and will be ignored for those export types

  • Date - Inserts the current date; users can select from a wide variety of predefined date formats using the secondary keyword drop-down list

  • Time - Inserts the current time; users can select from a wide variety of predefined time formats using the secondary keyword drop-down list

  • External Link - Inserts an external link that directs to the web client version of the export; this keyword will be ignored in XLSX and XLS exports since Excel does not support links in headers or footers

  • Global Variables - Inserts a global variable; users choose the desired global variable from the secondary keyword drop-down list

 
Note  

Certain keyword options are exclusive to Worksheets, Dashboards, Reports or Charts, so it is normal if some keyword types do not appear when a user expands the Insert Keyword drop-down list.

Note  

Header or footer text can overlap as shown in the image below. If that happens, users can re-open the Header or Footer Customization pop-up and add the necessary spacing, indentations or line breaks so that their text does not overlap.

Users should always review the header and footer preview in the Header / Footer tab before clicking the Confirm button.

Grid Tab

Related to Worksheets

The Grid tab (shown below) allows users to configure their export's column headers.

Fields and Values

Column Header - Toggle that determines whether or not column headers will appear in an export; for the two other Grid tab fields to appear, the Column Header toggle must be activated

Repeat Column Header - Toggle that determines whether or not a worksheet's column headers will repeat at the top of each page break when exported

Column to Repeat on Left - Allows the user to specify how many of a worksheet's columns will be shown when exported; the value indicated cannot be greater than the number of columns in the worksheet

Report Tab

Related to Reports

The Report tab (shown below) allows the user to configure both the column headers and report title of their export.

Fields and Values

Column Header - See explanation in the Grid Tab section above

Repeat Column Header - See explanation in the Grid Tab section above

Column to Repeat on Left - See explanation in the Grid Tab section above

Show Title - Toggle that determines whether or not the report's title will be shown when exported

Repeat Title - Toggle that determines whether or not the report's title will be repeated at the top of each page break when exported

Export Types

Nectari supports the following export formats—PDF, XLSX, XLS, CSV, HTML, XML and PNG. However, all formats are not compatible with all export types.

Note  

Fit to features are only compatible with PDF, XLSX and XLS type exports. Exported Charts and Dashboards both automatically fit one image per page.

 

Example PDF Export

Example Excel Export

Page setup configurations (e.g., Header / Footer and Fit to) are not immediately visible upon opening the export in Excel, however, they have been imported. If you click on the Page Layout tab in Excel then open the Page Setup window, you will see that your configurations have been imported from Nectari. The screenshot below shows the Print screen of an Excel export from Nectari with both headers and footers.

Example HTML Export

Example PNG Export